

INSERT INTO cat_ranking
SELECT top 10
newid() AS [Id],1 AS [OrderNumber],shortname AS [Text],NULL AS [TextStyle],NULL AS [Count],'company/' + Convert(varchar(50),id) AS [NavigateUrl],3 AS [AreaCode],1 AS [IsPosted],NULL AS [Notes],getdate() AS [DateCreated],getdate() AS [LastUpdated],'00000000-0000-0000-0000-000000000053' AS [MobifiedBy]
from [cat_company]

